Meal Application Extract

Reports > Eligibility > Meal Application Extract

1. Name - enter a report name
   Default: Meal Application Extract
   Template (not pictured) - select a report template

2. Reset - click to reset to default options

3. Student - filter by specific students

4. Academic Year - filter by academic year

5. Gender - filter by gender (Male, Female, Non-Binary)

6. Races - filter by races

7. Student Tags - filter by student tags

8. Ethnicities - filter by ethnicities

9. Allergies - filter by allergies

10. Include Inactive - check to include inactivated students, staff, and buildings

11. Schools - filter by enrollment school

12. Enrolled On - filter by enrollment date
    Default: Today

13. Enrollment Start Date Range - filter by enrollment start date range

14. Grade Levels - filter by enrollment grade level

15. Homerooms - filter by enrollment home rooms

16. Enrollment End Date Range - filter by enrollment end date range

17. Application Source - filter by Application Source

18. Application Processed Date Range - filter by date of processing

19. Eligibility Start Date Range - filter by eligibility start date range

20. Application Question - filter by Meal Application Question

21. Has Application in Verification For School Year - filter for students selected for verification for the selected year

22. Eligibility Statuses - filter by application Eligibility Status

23. Eligible On - filter by eligibility date

24. Eligibility End Date Range - filter by eligibility end date range

25. Eligibility Determination Reason - filter by eligibility determination reason

26. Eligibility Benefit Type - filter by eligibility benefit type

27. Has Eligibility Change - check to narrow results to students with a change in eligibility

28. Error Prone - check to filter for students with an error prone application
    Error Prone = income-based application that is within $100/month of the income threshold

29. Verify for Just Cause - check to narrow results to students on an application marked as Verify for Just Cause

30. Save as Template - click to save the selected filters and columns as a template
    

1. Name - enter a template name

2. Public - check to make the template available to other users

3. Security Roles - select the security roles that can access a Public template

4. Cancel - click to return to the previous screen without saving the template

5. Save - click to save the template

31. Reset - click to reset to defaults

32. Request Report - click to request report
    Note: Report will appear in the bell icon when complete

Included Column Order & Definitions

Column	Definition
Identifier	Student Identifier
Application Number	Application number from the meal application
Enrollment Building ID	Enrollment Building Identifier
Benefit Refusal	YES if Refused Benefits box is checked, NO if unchecked
First Name	First Name of student
Last Name	Last Name of student
Middle Name	Middle Name of student
Date of Birth	Student's Date of Birth
Application Address Street	Street address from meal application
Application Address City	City from meal application
Application Address State	City from meal application
Application Address Zip	Zip Code from meal application
Application Phone	Phone Number from the meal application
Application Email	Email address from the meal application
Total Household Members	Total Household Members
Application Race	Race from the meal application
Application Ethnicity	Ethnicity from the meal application
Eligibility Benefit Type	Eligibility Benefit Type
Total Wage	Total Wage
Total Wage Frequency	Total Wage Frequency
Application Address To	Address recipient from meal application
Household Member First Name	Household Member First Name
Household Member Last Name	Household Member Last Name
Application Benefit Number	Eligibility benefit number from the students meal application
Application Approved Benefit Type	Eligibility benefit type from the student's meal application
Household Member Work Wage	Household Member Work Wage
Household Member Work Frequency	Household Member Work Frequency
Household Member Pension Retirement Other Wage	Household Member Pension, Retirement, Other Wage
Household Member Pension Retirement Other Frequency	Household Member Pension, Retirement, Other Frequency
Household Member Temporary Income Unemployment Wage	Household Member Temporary Income, Unemployment Wage
Household Member Temporary Income Unemployment Frequency	Household Member Temporary Income, Unemployment Frequency
Household Member Welfare Child Support Alimony Wage	Meal Applications > Household Members
Household Member Welfare Child Support Alimony Frequency	Meal Applications > Household Members
Application SSN	Last 4 Digits of SSN from the student's meal application
Application No SSN	YES if No SSN box is checked, NO if unchecked
Child Income	Child Income
Child Income Frequency	Child Income Frequency
Application Receipt Date	Date application was received
Application Academic School Year	Academic School Year
Enrollment Building Name	Enrollment Building Name
Eligibility Status	Eligibility status Note: Covert Code if feature is enabled
Raw Eligibility	Eligibility status without covert code
Is Directly Certified	YES if the student is Directly Certified, NO if not
Eligibility Start Date	Eligibility Start Date
Eligibility End Date	Eligibility End Date
Eligibility Determination Reason	Eligibility Determination Reason
Direct Cert Import Template	Direct Certification Import Template Name
Application Source	Application Source
Application Processed Date	Date the meal application was originally processed
Application Processed By	User who processed the meal application
Application Language	Language from the meal application
Error Prone	YES if the meal application is considered error prone, NO if not Note: Error prone indicates that the application was within $100/mo of the eligibility threshold
Application Question Answers	Answers of additional questions from the meal application
Included in Verification	YES if the student is included in verification, NO if not
Is Extended	YES if the student is eligible because of extended benefits, NO if not
Automatic Extension Reason
Previous Total Household Members	Total Household Members of previous application
Previous Total Wage	Total Wage of previous application
Previous Total Wage Frequency	Total Wage Frequency of previous application
Has Eligibility Change	YES if the student's eligibility has changed, NO if not
Previous Eligibility	Eligibility of previous application
Previous Eligibility Benefit Type	Eligibility Benefit Type of previous application
Previous Eligibility Start Date	Eligibility Start Date of previous application
Previous Eligibility End Date	Eligibility End Date of previous application
Previous Eligibility Determination Reason	Eligibility Determination Reason of previous application
Previous Application Source	Application Source of previous application
Previous Application Processed Date	Processed Date of previous application
Previous Application Number	Application Number of previous application
Current Date	Date the report is generated
Application Address	Address from meal application
Person Type	Student or Staff